But according to @thedistinctivegardener, a self-contained one like this wall fountain works well because the water remains ...

You can go for a wall-mounted fountain. It lends a nice vertical dimension to the area while not cramping on space. Garden ...