I don't know what it is about Michigan's park system, but they seem to choose water spigots randomly as it is different for each park I've been to.
Higgins Lake North had the worst spigots I had ever encountered. They were only good for filling buckets, but they looked awesome. Each was a hand made stone covered cement column, with a handicap push button and a pitcher-pump style trough the water flowed out of. There was no way to attach anything smaller than a 4" hose to that trough, and even hitting the hole in a tote would be a challenge.
At Tahquamenon Falls, the water spigots were still turned off (I was there for labor day), but they would have worked with a hose-bandit type adapter.
St. Ignaces had the best I've seen... actual threaded spigots, with a handle that stayed on until turned off... By the time I had stayed at St. Ignace, I had gotten over my phobia of filling at the dump station, so I did not need in-park water.