I had the opportunity to meet with Peter Gleick of the Pacific Institute last week. They're doing some really interesting things with water and climate change, and they vigorously oppose the wastefulness of bottled water.
And they've done something about it, creating the WeTap smartphone application for Android phones, letting people know where the nearest water fountain is located, and ultimately letting them input new fountains, as well as providing feedback if a fountain needs repair.
These video links don't always work, but I talked about it yesterday:
(If you can't view the video, click here, then click on the January 31, 2012 meeting video, and in the pop-up window advance to 04:47:00 time frame.)
I believe the crowd-sourced, added content feature isn't yet available, but that's part of future plans. Santa Clara Valley Water District itself encourages drinking our water and discourages the wasteful practice of bottled water, which we've banned from our cafeteria and our events. WeTap is an excellent tool to help people make use of their water.