I recommend Splash Down Beach (SDB) Water Park. http://www.splashdownbeach.com/

It has nice water activities for everyone in your family. Small kids can enjoy Bob the Builder Splash Works and Shipwreck Lagoon. The more adventurous can try Humunga Half-Pipe and Pirate's Plunge.

And everybody young or older can enjoy The Monster Wave Pool and Croc Creek Wavy Lazy River