Hi John. I have one.
There are basically 2 types. Sit in and sit on.
The sit in kayaks (of which I have one) are better for paddling , being generally longer (15' - 16') and glide better. So if you want to explore, these are better for it.
If you want to go fishing, there are all sorts of sit on type kayaks which come equipped with almost everything you need, including rod holders, cool boxes etc. Trot into Anaconda or BCF and look at the options. These are a bit more stable but marginally more sluggish in the water. Great fishing platforms according to some of my mates.
Good fun.
Enjoy.