To get you and your 9 year old fishing, using lighter 7' rods with small Storm shads or Cocahoes on jig heads early morning or late evening (morning preferred).
Plenty of water from home to work to fish with the kid. Also, see Mike at M&Ds on Main St in Wareham - great shop, prices, and he can give you better local info on where to go and probably offer advice where to take the kid.
Don't forget worms off a pier for cunners are fun for a 9 year old too
Welcome to S-B