Rain water harvesting and Open Well digging

[msn1270]

As you mentioned most of the depth is full of Rock, You can make use of good water filtering system and pass the filtered Rain water directly to the Borewell itself.