This has been discussed before on HN. Quoting an actual engineer from faulty memory: Boring a tunnel through the mountains is well beyond what's currently doable. Doing it on the surface would require lifting the water a few km up in order to let it flow down on the other side, and would be the largest engineering project ever, expensive to build and equally expensive to operate. Total water use (including farming and industry) may well be well over 1000kg per person and day even if it's restricted because the water is expensive, lifting that weight several km requires a lot of energy and expense.
Sorry about the word effective, it should have been efficient. I used the word because the pumps may be compared to other means of transport in terms of water moved per joule spent.