Eddie,
I will be following your progress with great interest. I am about a year out from doing a very similar project.
My initial thinking was similar to yours - basically, use a solar deep well pump to fill (keep filled) an above ground cistern and then use the cistern gravity/water pressure to target water my garden layout . I also struggled with how to "blend" the cistern into the area without looking like an after-thought.
With the help of a farm designer (who knew they had people who did that sort of thing), I decided to make the cistern a focal point to a greenhouse and garden layout that will be more formal in nature, but still a working garden.
I have linked below the cistern look I will be going for (Taken from a photo I saw on Houzz) and the greenhouse/garden layout.
The cistern will be in the center of the garden area versus trying to hide it or stick it next to the greenhouse like a sore thumb. I know your longer term plans for your property, so you may want to do something similar if this will be a visible area for your property and future guests.
As I am still in the design phase, so I don't have too much to offer you on a proven method. However, I have spent some time googling small winery irrigation examples. There are several examples of small vineyards using cisterns to water their vines and nut trees using small drip and emitter runs. Nobody seems to be doing the "just throw water in the air" and cover everything approach with a cistern.
My initial thinking was a 3000 gallon vertical tank sitting on a concrete pad that I would surround in cedar and get the lid/cover fabricated to hide the poly tank. They have cisterns all over Texas that can be erected on your site and then lined with a liner, but I figured it would be cheaper to just buy a vertical ploy tank and frame around it. I am not 100% this is correct, however.
If I come across some specifics in my research I will be sure to post the findings. Good Luck!

