I have 2 large dogs and they can be quite a handful while camping or fishing with the kids. Back in the day before the kids they would have been no problem, but now we usually get a dog sitter for fishing trips or they stay at the cottage. I love my dogs regardless and would love to take them everywhere but it's not possible a lot these days. For week long vacations they always come though.
I don't see any problems with hotels or campsites.
I can see you guys being very happy with a new fishing partner.