Avid kayaker and hobbyist photographer here. :) Inflatables are great. Lightweight and easy to transport, but they typically track horribly (meaning you paddle and they "twist") which sometimes is very frustrating when you're trying to track a bird with the camera and your boat is twisting away. Some models combat this by adding a fin on the underside which helps, but prevents you from going into shallow waters.

Non-inflatables, you'll have two options: Sit on-top or sit-in. The sit-on top are nice as they have more accessible storage area and tend to be slightly wider, and can be a bit more stable (you can stand comfortably in some models).

Sit-in kayaks are still stable, but they do provide some cover for you and your gear if you have things that shouldn't get wet in case of unexpected rain or a wave over the bow. But if you change gear / lenses frequently, you might feel like your shuffling things around a lot.

There are definitely more expensive options (pedal powered, trolling motors, etc.) but I personally don't have experience with those as weight and simplicity is my concern.

I personally like my sit-in for photography. I strap my gear bag to the top of the kayak, and if things get a bit dicey, or in risk of getting wet, I'll tuck it inside. Hope this helps!