I would suggest Pattaya Park as a Water Park for you to spend during holiday in Pattaya city. Getting some other Hotels on the beach would be more comfort ( actually me) or Hotels on second Rd if you love shopping! as well as Jomtien beach for quite environment.