Fountains may seem like the perfect way to create a garden oasis, but they come with many drawbacks, such as the price tag and the location of your home.