Adding an outdoor water fountain probably won't directly add value to your home, but it will very likely add value to it if you're looking to sell. And for a possibly lower price for a landscape element, your investment could be worthwhile.