I work as an EMT, and unfortunately, worrying about kids and water
isn't hysteria, it's wisdom learned the hardest way.

A water feature that's screened or is a little brook over rocks would
be beautiful and safe. There's no reason you can't have kids and ponds,
as long as safety is your first concern. It sounds like that's the
case, so good for you, Mom!