Yes, kayaking is awesome and from the map your area looks like a prime kayaking location.
I have both fully rigid kayaks and folding kayaks.
No kayak will be best in all circumstances so you have to look at what you want out of it:
For good performance you'll be looking at either fully rigid or folding. Inflatable are slower and not as nice to paddle because they tend to be wider and lack rigidity (modern high quality inflatable seem to have improved a lot in this area but I haven't tried one in a long time).
If the lake has very shallow water with sharp rocks below the surface, avoid folding kayaks as their skin is prone to punctures (beaching them on pebble is not an issue, they aren't that fragile but crashing full speed on a reef is better avoided). Inflatable are more puncture resistant than foldings but probably more difficult to repair (repairing the skin of a folding is very easy, no experience with repairing an inflatable but I assume it's more difficult because the repair must old the air pressure).
If you want to move your kayak over long distances (or lack storage space), fully rigid will be a pain. It's fine to put it on the roof of the car to drive to the local lake, but I wouldn't take it on the highway and on long drives. Everytime I go to vacation somewhere that has a lake or a calm sea I take a folding kayak with me, I wouldn't/couldn't do it if I only had fully rigids.
If you want to take your kayak on rivers with gentle rapids from time to time, inflatable would be best (even the only viable option I would say, a rigid filled with water will be too difficult to recover, same issue with a folding on top of being too puncture prone). Obviously for any rapid beyond class 2 you'd need a proper whitewater kayak anyway.