You'll need 10.4+ psi to overcome 24' of head. That doesn't account for any frictional losses or the resistance of the foot valve either.

The real problem is that you're talking about pressurizing your entire aquifer with a 1.25" low pressure line. If the aquifer were like a sealed container, this would theoretically work. Unfortunately I don't think you can consider the aquifer "sealed". I think the water will move laterally underground as you try to increase the pressure. A relatively inexpensive way to check would be to pipe in a small compressor and see what happens.