Having been raised in Michigan's U.P. I am familiar with the Bays de Noc area.
Both Little and Big bay de Noc have good pike fishing. You may want to look into guide services to get you on some good fish. It's kinda hard to go for a weekend and
try and find fish if you are not familiar with the area.