The easiest water pumps for fountains are called well pumps as well as are commonly used for providing water to houses and also structures or structures. The water is gotten from a below ground source as well as the capacity with which it is provided via the pump is dependent on what does it cost? water is needed.