I avoided outdoor water features for years because I had one idea in my head, a mossy tiered fountain outside a restaurant with a cherub on top, and that's not a vibe I'm bringing into a backyard with a plastic kiddie pool in the corner. What changed was standing in a friend's tiny patio in the rain, listening to a small bubbling pot by her back door, and realizing it was doing more for that space than anything I owned.
If you've got none, start small and start simple, a single basin or pot style fountain that recirculates its own water, the kind you fill once and mostly forget about. No pond, no pump system that needs a degree to understand. Put it somewhere you already sit, by a back door, next to a patio chair, on a deck rail if it's sturdy enough. It sits well next to the stuff you already have, terracotta pots, a plain wood bench, string lights, nothing matchy. I've got mine near a cluster of basil and mint that I kill every August, and the sound covers for the fact that my garden is mostly ambition. It also does something sneaky and good, it masks the noise from neighbors, traffic, whatever your block throws at you, so a cheap bubbling pot earns its spot just by making other sounds less annoying.
This works best in a yard, patio or balcony you actually use in the evenings, not one you look at from a window twice a year. Small city balconies love these for the same reason they love string lights, low effort, high payoff. Family backyards with grass worn down from a trampoline benefit too, it gives one corner a reason to feel calm instead of chaotic. Summer is the obvious season, but I run mine into October before I drain it, there's something about a cool evening and moving water that feels better than a fire pit sometimes, don't tell the fire pit people I said that. In colder climates you'll want to empty it before a hard freeze, cracked concrete basins are a real and annoying thing, learned that one the expensive way.
The best part is how it changes with time. Stone basins pick up a pale mineral ring, metal ones streak and dull in a way that looks earned rather than neglected, and if you've got a concrete piece it'll darken and texture itself with algae and rain in a way that honestly looks better than the day you bought it. Nothing about a good water feature wants to stay new looking, and that's the whole point.