Victorian attraction reopens after five years, showcasing a £23m upgrade for visitors.