It's not an issue. Huge ponds are common as dirt around here, small ponds are what's rare.
,I want a small pond with a waterfall because I find it relaxing. A little waterfall, a firepit, and a nice whisky makes for a pleasant evening.
My brother-in-law has had a small pond in his backyard for around 25 years or so.
I've spent many hours out there sipping whiskey with him while having the fire pit going with the water rushing in the background so I can see the appeal.
Over the years I've talked to him about it and came to three conclusions.
1. The initial installation cost is steep. Stone, pumps, liners, chemicals, plants.....it goes on and on.
2. It took him years to figure out the right balance for a healthy pond. This is the maintenance aspect. Years, not days not weeks, not months but years.
3. I would never want a pond in my backyard. My Bro-In-Law spends so much time dicking around with his that I learned pretty quickly that it was just not for me.
But after 20 plus years of sipping whiskey looking at the fire and listening to some good music while the water is cascading over his waterfall.... Yeah I get the appeal. I'm just glad he takes care of it and not me. 😁