The auger you posted a link to is for fairly soft ground, as soon as you hit a rock it will stop dead.
How are you expecting the water to get to the surface? There will need to be a differential head in order for it to spill out of its own accord, and if you're pumping it out the soil/geological conditions around the suction nozzle may cause it to constantly clog up. Personally i'd pipe it in from a higher elevation, that way you've got your differential head.