Oil is significantly more valuable than water - the added cost per gallon of water would be astronomical.
1 oil barrel is 42 gallons and costs around $75 today. I pay about $6 per CCF of water which is 748 gallons. It might be worth doing this with oil, but even if you scaled it up, it would be hard not to have the transport cost more than the actual water.