The resort we stayed at had this awesome pool with a giant pirate ship in the middle. There were water slides and cannons that fired water back into the pool. Ty had a blast with this and it was one of the main reasons I picked this resort for us too.
(added later by request... The resort is Horizons by Marriott near Sea World)