Keep it simple
A golden rule with water features in small urban gardens is to keep it simple. A simple standing stone, a contemporary brushed steel column, or a water blade cascading into a pool that is built into a raised flower bed, often produces the combination of sound and aesthetics that make garden water features so appealing. Anything more elaborate than that, and you are getting into a more specialised territory that will require considerable maintenance and cleaning schedules as the years go by.
Having a source of water in your garden is also rather critical for wildlife. Even the smallest water feature can provide a decent source of hydration during a long hot summer. More birds, more polinating insects, more flowers. It’s a complex, and yet simple relationship that encourages more biodiversity and a healthy ecosystem.