The Popeye Barges will get you really wet. The Canadian Mounty flume ride will get you wet, and most of the time, really wet. Jurassic boat ride, may get you wet, especially if you sit in the front. The drop is amazing.
We stay on site, one morning we do all the water rides, then go back to the hotel for a shower and change.