You can get a waterfall fountain with little tree frogs all over. There also are dragonflies, angels, cherubs, fairies and Grecian ladies. Some feature rocks. Others are made of stainless steel, copper or glass. You can adjust the pumps to alter how the water flows and the sound it makes.
Different fountains tend to have different sound levels.
A waterfall fountain will make more noise than a smaller fountain in which water just gently flows over rocks. Some people find a trickle of water relaxing, while others want to hear a rushing brook. Let's talk some more about garden accessories. They have the texture of an old architectural piece. You can fill them with silk pansies, hydrangea or ivy.