It all depends on whether the fountain is inside or out... on what the other external forms are... on the specific qi map of your house.
You can't get far with generalizations such as "water destroy metal, and west is metal,"
Don't despair. The situation may not be nearly as bad as you think.
