If you are in the USA, the County Extension Office of your state university will have a list of plants that are native to your area. These plants should need little to no additional water once they are established. Be prepared to amend your soil before planting.

Go to a local plant nursery (not national chain). The horticulturalist on staff will be able to answer all of your questions.