I would try some test holes. Watch them for a year or two.
The first test hole I dug, I had water at a foot and a half down. It was only about 4 feet deep. Next year the water was gone. I dug to 6 feet in that spot, and to 8 feet in another spot. Both been dry for a couple years. I now know what is down there now, as my dad had a new well put in. 18 feet of sand/gravel, then 175 feet of grey clay, then into gravel where the good water is.
The goofy part about MI law is that if you use a backhoe to dig test holes for a pond, you need a permit from the DEQ. I used my Kubota with a FEL
