You can see more photos of waterspouts on Lake Michigan from NOAA, where they explain:
Waterspouts are somewhat common over the Great Lakes in the Fall season. Waterspouts in the fall occur when colder air above the surface moves over the still relatively warmer waters of Lake Michigan. Most waterspouts that occur in this type of scenario typically occur under plain showers and are much weaker than their summer counterparts. This fall type of waterspout is different from waterspouts associated with thunderstorms. They also form differently than waterspouts associated with thunderstorms.