They are usually strictly catch and release, but in a kayak could probably pull you a great distance. They are deceptively strong for their size, and a big part of local conservation efforts.
400 years is plausible, as they do live a long time when left alone. =3
To be fair, the towns you're talking about are barely 200-300 years or so I presume? Most other towns in the world are probably older than those towns, and maybe even the fish if it's just 400 years ago :)
My father was in the boat with me. After hooking the fish, it took about 20 minutes before the fish was close enough that we could see it from the boat, and identified it as a sturgeon - it was the only time I'd ever caught one. This one was so much bigger than anything I'd caught before. I was using one of those jointed Rapala lures, and it had hooked the dorsal fin. I can confirm the sturgeon could definitely pull the two of us, and the boat, upstream - but not a great distance - just enough to move the boat around.
After about 25 minutes, my line snapped (it may have been 12 lbs test). We didn't really have a way of getting it in the boat in any case, and we would have released it anyway. This was probably the late 80s/early 90s - so nothing captured on a phone camera - it just lives on in my Dad's & my memories...