A Hampshire attraction is about to undergo a multi-million pound transformation, set to include one of the UK's biggest indoor adventure parks.