There are lots of crappie locations near the big lake. Marinas, backwaters, bays, rivers, etc. Not sure you would need a guide for that though as alot of places can be fished from the bank. I happen to know a walleye guide tho if you need one.
My experience is places can go hot to cold to hot within a days time. I usually do pretty well, I only use shiners, and best fishing for my spots typically run in line with the white bass run.