Make a beautiful scene where ever you go
Fountains are a great public art piece for many reasons. Many fountains are large and really require a lot of room to really shine in the round. A public space gives that space. Also, public spaces give a large audience for these robust features. A larger than life fountain without guests will do little work in a private space.