The place is really fun. I was around before it was turned into camps, it used to just be open to the public all the time. The water ramps are sick, but that material is brutal (if you couldn't tell from the photo) so make sure you commit and the slip in slides are fun. The skate parks (indoor and outdoor) are fun and if you're into it they've got some cool bike trails. Oh, and the trampoline is fun too, super bouncy. They also have a little rail garden that I haven't checked out yet.
I know the owners and some of the coaches and they do an awesome job, you'll definitely have a good time.
Just hopefully the weather works out for you, it's been kind of shitty lately.