These family-friendly hotels on Lake Superior and Lake Michigan boast fantastic waterfront locations. They're perfect for your next Upper Midwest getaway.