Our house in Maine had a 3/4 acre pond @ 80 feet from our front door. When we moved in my youngest at the time was a baby and then I had one more baby. We lived there until he was 2 and she was 4. I didn't realize just how nerve wracking it was until we moved out. We do want land with a pond on it again some day but not one so close to the house.
So unless it was just a small babbling creek and not close to the house I am not sure I'd do it.