If you are planning on camping, don’t rule out a small solo canoe. They are seen in use less often than tandems but are a pleasure to paddle. Canoes can haul far more gear than a kayak, not to mention the fact that the gear will be much more accessible. I even paddle my 17’ tandem canoe on pine barrens streams by myself all the time with no problem. I sit in the bow seat facing backwards and my weight is distributed much better. And if you use a kayak paddle while solo paddling a canoe, you may never go back to a canoe paddle. No J-strokes or switching sides required!
I have both canoes and kayaks. You can’t beat a kayak for paddling directly or quartering into the wind on open water, but there are many other situations where I much prefer my canoe. But if you do get a kayak, don’t get one less than 12 feet long if you plan on any open water paddling. Shorter boats track very poorly on open water and can be exhausting in a wind. Even the canoes the liveries rent on rivers are a minimum of 16 feet, so a 12 foot kayak will not be a handicap. The shorter kayaks excel on whitewater where very quick, tight turns are often required. There are no conditions like that on our waters.