I used to take my dog local skiff fishing on my 14 ft skiff.
I'll be honest: I quit doing it because she would get too seasick. She hates seeing me go off alone, but it beats me watching her throwing up, shivering, and getting the shits on my deck.
I've never taken my dog kayaking. Unless your fishing lakes or enclosed waters I wouldn't even consider it.
Jim