Space may be the deciding factor for this water feature. For a small backyard or narrow side yard, a wall fountain or Japanese fountain is a good choice. Or consider a self-contained fountain that can go anywhere. A large, tiered fountain needs some space, and likely the help of a professional.