Your maple is suffering from chlorosis. The irrigation may be a minor contributor, but the most likely cause of the chlorosis is your soil. In many places in Oakland County the soils are very alkaline (high pH). In alkaline soils some of the nutrients in the soil are not available to the tree, creating a nutrient deficiency. In the case of red maples the deficiency could be iron, but it is often manganese. The following links will take you to sites that provide some information about chlorosis.

http://www.ext.colostate.edu/mg/gardennotes/223.html

https://www.extension.purdue.edu/extmedia/bp/bp-27.html

You may want to begin by having your soil tested. The test will indicate the soil pH and provide other useful information.  Michigan State University offers an easy way to test your soil. The following link will take you to the MSU soil testing site.

http://www.msusoiltest.com/

If this tree is an important part of the landscape, and you do not want to replace it, you may want to consult with a certified arborist about treating the tree for chlorosis. Some arborists will do an initial consultation at no cost. You can find the name of a certified arborist in your area at the website for the International Society of Arboriculture. The link to the site is below.

http://www.treesaregood.com/

The holes in the leaves look like the work of some type of caterpillar. It is important to identify which caterpillar before treating the tree because the insect may already be finished eating for the season. If this is the case treatment would not be beneficial. Carefully inspect the tree for any signs of an insect. If you have the arborist evaluate the tree, he or she may be able to identify the specific pest and determine if treatment is necessary at this time.

I hope this information is helpful. Thank you for using our system.