The Great Wolf Lodge water parks are a nationwide chain - in Kansas City, Kansas, I visited my second Great Wolf (the first being in Charlotte, NC) - it was small, but had very exciting rides and was an indoor park, which is great for a rainy day, and you can easily walk in and out of the park as you wish. Great Wolf requires that each customer stay at the hotel to use the facility - which cuts the crowds, but makes the park more expensive. This can be a little tricky, as if you're flying, a taxi from the airport can cost up to $60 each way, so a trip here can be rather pricey.
That being said, it's certainly worth it - not only do you have access to another waterpark (Schlitterbahn) and other things in Kansas City, Kansas, but the indoor water park Great Wolf offers is very fun.
Triple Twist - one of my absolute favorite rides ever. The rider sits on a raft and is thrashed around in three funnels, for a very thrilling experience.
Alberta Falls - A tube slide, moves fast and dumps water on the rider.
Howling Wolf - a 1-3 person raft ride, which moves into the dark.
Totem Towers - two exciting body slides. You have to navigate a kiddie playground to access them, but are great body slides - best of all, they don't empty into a pool where water gets up your nose. One of them felt similar to the Maui Wowie ride in Erie, PA.
Food: Great Wolf offers lots of food - there is a place for burgers and the like inside the park, but as it is easy to walk in and out, you can go out to some restaurants near the hotel such as Famous Dave's or Lone Star, and the hotel offers it's own restaurant as well as a fudge shop.
Transportation: If you're staying at the hotel, and coming from the airport, a taxi is your best bet - it's $60 each way. Fly into the Kansas City, MO airport (MCI).
Overall: Small, but exciting, and has plenty to do nearby.
Rating: 4 out of 5 stars