Families will welcome the move after the previous attraction closed suddenly in 2022 after just 15 months