Crowin Supply A decorative fountain is a type of water feature that is intended more for aesthetic and emotional impact than for functional purposes. It creates a visually appealing and peaceful focal point in a place by combining water, materials, form, sound, and frequently light.