Well black thumb...now I get it. I did this in a development and had a forest, seriously, that gave fruit, shade, interest and privacy. We had to leave and they ripped ALL OF MY PLANTS and hard scape OUT. Put back in lawn. I am still grieving big time.
There are things you need to consider. For example; the cactus in this guy's yard along with deciduous plants that need more water. Not cool. Amazing his is working. The shade for him might be a good thing with the temperatures. Otherwise forget trying to grow vegeys. I am not fond of soil irrigation, but I do not live in such hot hostile climates. All of those trees thrive in his zone but need extensive pruning...to do better in such a small space.
Please use scientific/botanical names of the plants you are lusting after. Common names can make huge mistakes. Send a sketch of your ideas and plant materials to include your home, water lines, water availability (don't make the mistake thinking you'll get away with no maintenance...that will take time)...electrical lines, wind direction, neighbors... any underground covered up concrete, check with your neighbors to find out what they are growing and what they've done...come up against.
Lawns, sadly are what most developments INSIST you have. We can work with that...I've done designs and installations to incorporate 'forests' as well as abiding by the covenant. Hey, Elderberries are fantastic! So are hops! I need to know where you are for sure. 6' to the water table??? euuuuww. Close and also impregnated with who knows what chemicals...check this out. Are you on a well? Or city water?
And before you get too invested, CHECK your covenants as well as your city's regulations. This is NOT a normally allowed thingy!