Attraction was closed for more than five years to allow essential overhaul to be carried out