There are various types of fountains, from elegant stone structures designed to be focal points of a garden, to decorative fountains perfect for a study or living room. The sound and sight of trickling water is naturally soothing and water fountains can be used in both outdoor and indoor settings.