It REALLY depends on what you are looking for. Bonnett creek has several pools, including a zero entry pool, kids play areas, and a couple lazy rivers. There are also some nice hottubs for the adults. I think they only have like 1 slide at one of the pools.
Most of the water parks will have wave pools, a lazy river, several different slides (Both tube slides and just you on the slide), as well as any number of other interesting thematic activities that could be based off the parks theme or just to make things more interesting.
I Think the Bonnet Creek thread here may have pictures of the pools in it, So since you know your kids, you may be able to determine if that's enough for you. You can also check the websites for the various parks around the orlando area to see what they have to offer, as well as any height restrictions that could impact your kid's ability to enjoy everything.
The 4 big water parks in the area are going to be the 2 Disney parks (Typhoon Lagoon, Blizzard Beach), Aquatica, and Wet & Wild. Typhoon Lagoon in some ways has the advantage in being right around the corner from Bonnet Creek, However keep in mind that it's Wave Pool is also the most "aggressive" and may not be the most enjoyable thing for small children.