Apparently, and this is canon; evaporation does not exist in Equestria. So, bearing in mind that while we did see a horse-made hurricane to deliver water to Cloudsdale, we can only assume that small amount would only account for the needs of Ponyville. What about everywhere else? Well, the siphon is the answer to that. I think.
It still seems just as inefficient as the hurricane method…