> Right now several apartment societies with 3000+ apartments in them are coming up in my immediate neighbourhood. So next year, we can expect the borewell water to be over way before june (early may?).

Do you mean that a permit had been given to developement project without providing adequate water supply first? And it will depend on borewells?

> Rain water harvesting doesnt works greatly in areas like ours which only get a few months of rain. Where will you keep the harvested water for the next 8-9 months?

Some desert cities in Palestine had a rain once in a three years. Still tanks provided adequate amounts of water.

Seems like India ain't lacking in water resources but in governance.