The Musquodoboit river has always produced for me. I only fly fish though. Not sure if that's what you're planning to do? The best spot I've found is just above Crawford Bridge. The river is very narrow there and when they run it's pretty cool to see the large number of fish that move through. If you're planning to use bait or spinners, I think you need to go 300M above the bridge but check the regulations to confirm. The tricky part is being there at the right time.