I have two cocker spaniels, one is getting on (9) and one is only 6 months old. We are in the process of training the pup, and we hope she turns out like the older dog, but they are both very different characters.
The point being, I try to be responsible. I always scoop the poop (and take it to a bin, though there is a distinct lack of bins anywhere these days) and when off walking both hounds are on leads. For one thing I am sure the pup thinks the canal can be walked on ! (well ducks do it don't they?). I must say I never realised there was such a depth of feeling against dogs ~ I can honestly say no-one I have ever met has backed away, complained or seemed concerned, most people seem to want to stroke, touch or talk to my two. I will be more wary now which I hope helps the non dog lovers.
We have found that very few pubs will accept us on the inside, so we either stay outside or we don't bother at all. I am not prepared to lock the dogs up in the boat or tie them on short chains and make their lives miserable.
There are a number of books available listing dog friendly pubs, a good one is published by the AA (that's the Automobile Association !)
Baron & Mrs B (& the dog crew)