That certainly sounds like it would be a challenge.
BTW... I wouldn’t even try to get a well driller involved.
I have what I “think” might be a spring. It’s not near my well.
Using a backhoe I have on my tractor, I have dug down about 6” from what was always a wet spot in a field. I would have gone deeper, but it turns to solid rock, large and thick shale rock.
I have dropped a sump pump into the water filled hole and every time the pump takes the level down, about 40 minutes later, the hole is full of water again. This occurs even during the driest part of the year. The water is clear, smells good and it’s very cold.
I don’t know anything about this stuff, but I think I might have a spring and if I do... there is my extra water source. ;>) At the very least, it seems that I should be able to bury a storage tank in nearby soft ground and use the source to keep it filled for gardening water.