I've driven a couple sand points.
If you have nice well-sorted sand they drive o.k. If you have clay lenses or cobble layers you have to go through, it can really stink. If you have to go more than 30 feet - I would forget a sand point.
You may find a some well log data near you in the database link below that will help estimate water table depth.
http://www.dnr.mo.gov/env/wrc/logmain/ Otherwise, if you have a lake, opnd or stream close by the water table is most likely a little higher in elevation than the surface of the water. If you have springs that come out of slopes above these water features, you can assume the elevation of the spring is pretty much the elevation of the water table. You then have to figure out how much the land rises from the point you want the well to the water surface.