I have two pretty close together
They just get in the way of my paths and landscaping though because my Train station, Retail and Town hall are almost all in their area together… with the two ponds under the station and between my retail and town hall plaza.
The other is like really out of the way directly in the corner behind my town hall
I have three! Ugh. I wish I had only one. When I started my town, I liked the first map I saw, and wasn't thinking about the number of ponds. I do love the rest of my town's layout, but the ponds are just in the way of PWPs and paths!
Also, unlike previous AC games, I never see any shadows in the ponds...
*I did place the picnic blanket next to one of the ponds, so that is cute, at least!