New water park set to open in Scottsdale