We really like Kalahari and Wilderness Resort. We haven't done anything but the waterparks. I mean honestly it's one stop shopping.
Kalahari is pricy, but their indoor area is the biggest available and it's all in one place. The African Safari theme throughout is amazing.
Wilderness is more spreadout but it's fun to walk around to the different pools and the kids LOVE the tram (its free). The kids love saying "lets go to the wave pool this morning" or "lets go the red slide pool today".
We always get the bigger rooms/condos with the kitchen. That way we can buy groceries, take naps, watch movies we brought from home complete with popcorn, etc without feeling crammed in a "hotel room".
For the little kids, I don't think you'll need anything more than the resort/water park. We always pack some crafts and cook together. (Like making cookies, dipping pretzels in chocolate, etc.) The kids talk about our crafts and cooking much as the slides!