My uncle used to drill and frack wells. I set pumps on the side. Saw many wells become usable via fracking. Storage is another option. 4 gal a min is plenty!
I went through something similar. Picked up some property and had a glance at the well log and saw that it read 5gpm and 205 ft. I had my house 80% built before I realized it actually read .5gpm on the shitty photocopied well log I had. We spent a bunch of money setting up a cistern but after looking at the well depths around us we decided to drill the same well deeper. Ended up with 15gpm and ditched the cistern. The minimum gpm to subdivide up here in BC is .5 gpm so developers usually have the well drillers quit the second they get that much water to save them money. Lesson learned .