I've heard the name Schlitterbahn a lot in water park conversation, and I remember seeing them featured on some Travel Channel special. I remember they showed the blaster tech that they invented and use for some of their water rides. Looks pretty cool!
Closer to home, you have Aquatica, which I find to be very nice. Plus, you have the theme parks close by