I would suggest a beach. I've never met a child who didn't enjoy going to the beach. I suggest Destin, Florida. It's probably the safest because the water is completely clear.

I went there last year and could still clearly see my feet in five foot deep water.