What makes a good Water feature/ fountain

You can view this article to have a better understanding of what makes a good water feature in or out of the home:-

http://www.geomancy.net/resources/art/arowanafish.htm