It would be a little more than an hour drive for you, but the smelt fishing in Keweenaw Bay has been fantastic. Usually go out an hour or so before dark and the bite has been really good. After dark, you set an underwater light just about 10' or so below the ice, and it will attract the smelt. Can easily get over 100 smelt within a couple hours on a good night. Lots of fun for kids, and some great eating as well!
Good Luck!