We went last weekend for my stepson's birthday and it was a lot of fun!  There are four big slides, two which are tube rides that you can ride solo or with another person, but in general, it is geared to children 10-12 and under (in my opinion).  There is a large water playground area with hoses and slides, a small pool to play basketball and a whirlpool. 

There are some food options and a bar.  It's nice and clean because it just opened, and it's very well staffed!  You have the option of sleeping over, as it is located in the Sheraton.  Birthday parties and private functions are an option.