Great thread! being actively involved in farming, that too in a hot and dry area like Solapur, I can give a few useful insights on this.
1- There are two ways here, one being a little superstitious, the other being Techno-Logical. In my experience both have been super successful.
First the Superstitious, As my farm is just on the Maharashtra-Karnataka border I know a few things about local farming on both sides including understanding Kannada

. There are these 'Water Locator Men' in local language, they are sort of semi-god men types, talk to your farm neighbors they might help you connect with one. These men the come to your farm, conduct puja and then with their 'heavenly connection' locate a point where there is the most possibility they take a very nominal fee like 500 to 1000 rupees. I do not endorse this, although this method is followed ritualistically in my region, and northern parts of Karnataka.
Second the Technological, govt. of India has this wonderful website called Bhuvan, You can source the "Ground Water Prospects" Data Map from there for free. It is a hardly 5 minute job, this will help you understand the prospective location with estimated yield in liter per minute and the depth of water table. Attaching images for your reference. To explain the process I have marked my farm for better understanding of the process & outcome.
Go to the Bhuvan Website, select your State, it will direct you to your State Portal. Here select the satellite imagery tab and locate your farm land.
On the right side you will find the tools tab, use it to mark your plot boundary. Now on the left side Click on the ground water prospects tab and tick on Ground Water Prospects. you will see a colour patterned map depicting the state of underground water source in your plot. On the Left side bottom there is the Legend tab, click on it to interpret the same.
Ideally above 100-200 LPM is good enough to do small scale farming with Drip Irrigation (this is what I practice). 50-100 LPM shall be good for just Plants, but do use Drip irrigation to conserve water for plants too.
2- This will not matter as the borewell generally pick water from under the impervious layer of Earth from aquifers, and hence generally stay unaffected from roots. Bangalore and its outskirts are notorious for ridiculously deep water levels, was conducting a Geo-Technical survey in Devanahalli, was surprised to find average water levels at 600 feet below ground level, That too Hard Water.
3- Just any time, But do remember get it done in Summer, a borewell that survives summer should be good for all the year. In monsoon, many a time there are chances you may hit seasonal pockets. I have done all my 3 bore wells in summer.
4- This is a bit contentious I have a few relatives in Gadag who said that after a certain depth one needs to obtain permission, so surely there is some regulation in Karnataka. Anyways talk to the borewell guy/locals they have better expertise on this.
5- Vertical Drilling rig and clearing with compressed air is the most common one, it is the standard process. Also there are horizontal borewells dug in physical Wells which have dried off, it is a completely different topic though.
6- PVC & UPVC with slotting provision is used. generally weep holes are made in these casing pipes before slotting in the ground, this job is done by the borewell guys itself. Casing pipe cost varies yet a 20ft long casing pipe costed us 900 rupees a year ago. We used 3 such casing pipes as loose soil is encountered in our area up to a depth of 50 feet. Once hard strata is achieved no need of casing.
7- Charges may vary, yet to give a glimpse of what is current approx. rate in my region and parts of Northern Karnataka, following are the rates:-
Normal Boring-
0-100ft 60 Rs. per ft
100-200ft 80 Rs. per ft
200-300ft 120 Rs. per ft
300 and above 150 Rs. per ft
Casing Fitting and Boring this has higher cost as it involves boring with a bigger head, and multiple processes.
250 Rs. per ft
8- Nothing great, Just be aware of one thing, talk to your neighbors to know the average depth of their borewells and at what level they have encountered water. Worst case scenario is that you may not hit water. Now say the average water level is 600ft below ground level in your area, while boring you have hit 700 ft and yet have not encountered water, the boring guys try to make more money they will tell you "sir lets go 200 ft deeper' here the anxiety catches the better of you, hence keep a local guy along with you.
Now some additional points.
9- based upon the quantity of water hit, the Bore operator will recommend a Motor and Pump size to you, Go with a reputed one, I personally trust Kirloskar, they provide 5-7 years of unconditional warranty. Especially as water around Bengaluru is hard, hence go for the best, it will be 12-20% costlier but worth in long run.
10- Have a stable 3 Phase electricity connection, the motor will not work on regular Single Phase connection. Have stabilizers in place. if possible give an application for a separate transformer for your plot if required, we have done this. Unstable/fluctuating electricity can spell dooms day on not only your borewell but also Farm house equipment's in future, our farm house earlier drew electricity source from 3 phase connection, yet once with all stabilizers in place our Refrigerator, Water purifier and Bore Well Motor blew up due to bad surge in electricity.
On the other side if you can avail solar energy, then there is nothing like it.
11- If you are going to go to your farmhouse only on weekends and if you do not have a caretaker it is a bad thing for the Plants as they will require water daily especially during summer for the first 6-8 years. Do not worry there is another technical solution to this.
Connect all your plants with drip irrigation pipes and this drip pipe shall be connected to your bore output pipe. There are auto on/off switches available for bore motor which can be activated by mobile app(Costlier one) also there are programmable auto switches(Economical ones) available in which based on electricity availability, the switch turns on automatically for programmed amount of time daily. Thus automatically watering your plants.
12- If hard water encountered, you have to take a few treatment steps, as hard water though is okay for coconut plants, it is not good for other fruiting plants. We have hard water and our Mango, Chikkoo, Custardapple plant suffered initially, my uncle suggested adding some type of gypsum compound to the borewell and post that the water quality has improved(yet I don't know what were the technical details of the stuff added as the job was done by my uncle and father)
Adding image of my farm and farmhouse as a motivation, we began all this in 2015 and after 6 years it feels like heaven! hence all the pain efforts and money is worth!
