We have ALOT of indoor dwelling animals. Filling water bowls all day is time consuming. We have shopped for the fresh flowing commercial pet water fountains and found them to be expensive, low volume and poor quality. I came up with a high volume no frills alternative. Extremely easy to put together and very inexpensive. The critters all drink from it...large dogs to cats. The basic idea can be made to what ever fountain configuration your imagination can concieve.
Step 1: Basic equipment
One large water tight container and one smaller container. Consider the size of your smallest critter when choosing container size and height.
Smallish clean rocks to mostly fill the small container and hold the pump inplace.
One small, low volume fountain pump. A larger, high volume pump may shoot the stream on to the ceiling or across the living room.