Firstly have you any idea how far from the top the ground the average water table level is ? You should be able to find it on line by putting something like , " How do I find my water table level" , into your search engine .
If it is only a few metres down hiring a hand held engine driven borer with several extensions from the big tool hire boys should see you get deep enough into it so you can have a deep sump for the pump .
Be prepared to look at different borehole linings as well .