Great for crabbing so long as your DS don't fall off the wall (make them lie down with just arms hanging over the edge?) You can buy a crab line and a bucket very easily. I think baiting with cheap bacon works best. Hours of fun!
Harbour boat trips are great also.
There is a good playground on the right hand side as you face Dartmouth from the river.