Some people like water features. I have a small pond. I have a spitting frog and a little waterfall. I like the sound of running water in my back yard.
Some people just have a fountain pump that acts like a decorative sprinkler and bubbles water in a little pool (or a big pool).
The house today had a water feature. It was in the basement. Not your normal location for a water feature. I don't think that a water feature was the intended outcome of the installation however.
This house has a water problem. Water is coming in from the surrounding ground and runs to the low point in the basement. The corrective action was to dig a hole, install a bucket and a sump pump. All went well with the installation. They dug a little trench to direct the water to the hole. The drilled a zillion holes in the bucket so the water would flow in. They bought a really nice sump pump. They found an extension cord so they could plug it into an outlet in the basement (another story). They did it all.
Except one tiny little thing. They forgot to add a pipe on the discharge side of the pump so the collected water would be pumped OUT of the basement into the yard, AND away from the foundation.
So the bucket filled up, the pump kicked on, and the fountain started flowing. Sprayed water all over the place, so it took a little while for it to fill the sump again for another blast.
Got to love it.