This is a very important question. It relates to the selection of a water resistant trees deficiency linked to drought for the reasons you mentioned. Provide timely responses on my part would be indecent because it takes its specific proof that require time. Given that I live in Algeria I have traveled through a north-south transect that crosses our bioclimatic. Many of our regions are deficient in water especially in semi-arid Sahelian bioclimatic zones. Each of our regions have a specific feature not only on the rainfall map but also heat. It is important to note in each region indigenous and even introduced species that are resistant to drought. In general I noticed that the Pinus and Cupressus genera are quite resistant in many of our regions with a large water deficit. I think particularly of the species Pinus halepensis, the Cupressus sempervirens variety pyramidilis and horizontalis. What do you think of Cupressus dupreziana very drought resistant lives endemic Tassili N'Ajjer. This is one of the world's threatened species according to the IUCN, not because of drought but especially overgrazing. I can cite other kinds Olea and Acacia represented by the species Olea europea and Acacia horrida.
To combat water crisis issues Eucalyptus species trees are banned in many parts and in areas it is avoided. Plantation of some xerophytic species is aslo promoted by the field managers.