I’d second the advice from DRWyoming.
I paddle in northern Canada in everything from warm summer water to ice-skimmed winter ponds.
Taking a kayaking course is a great starter to get you familiar with the boats, then practice tipping and reentry with your own boat, as inflatables have different things that work than hard-shell kayaks.
Make sure the boat is rated for the water you’re on — most manufacturers will tell you the boat’s rating.
Be aware of water temperature and seek education on appropriate practice and clothing for any cool to cold water.
A fishing PFD is useful for photography, as they have pockets for teleconverters and your locator beacon.
(I use an NRS Chinook fishing life jacket and an Ocean Signal PLB locator beacon.)
An open cockpit kayak allows you to carry a submersible backpack for your rig that you can seal up when mounting and dismounting the kayak.
I use a CORSurf 40L paddleboaring pack for medium size telephotos (180-600mm) and a 50L MEC Sculley river runner for the big 400 2.8 TC.
Ditto Wyoming’s comments on inflatables — also look at the height of the seat. Some boats sit you high, so shooting angle is not ideal.
My current boat is an Airvolution2 drop-stitched rigid inflatable, open cockpit kayak.
It’s rated for Class II water, and I keep it in those conditions.
It’s stable enough to stand in, though I don’t do that with my rig
, and it handles chop up to 2’ with grace and handles rough log snags and rocks with ease.
I’m planning on adding a Swift Pack Boat (a carbon-fiber open cockpit boat that looks like a canoe but has a kayak seat and uses a kayak paddle). Similar to the Hornbeck boats.
Much less stable, than the Airvolution, so I’ll keep it to tamer water. But much more convenient than the inflatable.
Cheers and good luck!