I can tell you our situation about digging a well and maybe it will help. Our pond is roughly 3 acres in size.

We do have electricity, but instead of running wire all the way to the pond(~100 yards) we saved money by digging a long trench just below the well output. The trench empties into a tiny pond after 25 yards before traveling the rest of the way. This is time consuming and I'm sure we lose a little water along the way initially but it was way cheaper and it also allows the water to make some exchanges with the ground/atmosphere before dumping straight into the 3 acre pond.

Our measurements have us at 28 gallons per minute. We would have liked to have more but didn't want to fork out the extra money. 28 gallons per minute is still a lot of water. So far so good. We haven't experienced a hot summer yet so who knows what that will look like.

Ephesians 2:10