The water park is not overly big, but it was just perfect for our family. Because we went on a Thursday, it was not crowded at all and we basically had the whole park to ourselves. They had 3 big waterslides, which Daryl and I really enjoyed, a wave pool, and a kiddie pool with some water toys and small slides. 
Our overnight stay in the hotel included 4 passes to the waterpark that day (4 pm to 9 pm) and also 2 hours the next morning (10 am to noon/checkout). It was perfect. The kids had a blast, even though they petered out rather quickly, but that was okay too. I think it will be even more fun when the kids are older (and taller) so they can ride the big slides and the adults can ride them more too!