Any kayak will get you out there, you really don't have to paddle too far, your choice of kayak should suit your fishing requirements not your location requirements. You will need rod holders, storage space for tackle dry gear etc. some where to put your catch, some flat space to mount electronics if you go down that path and the list goes on. The choices in kayaks that fit this criteria nowadays really are endless. To get better value for money, buy 2nd hand, they come up often in the classifieds section, so keep your eyes open as there are some very capable and well equipped kayaks that get sold pretty cheap at times, you just need to be in the right spot at the right time. Check the wiki section on the front page for a run down on choosing a yak and reviews on all sorts of shapes and sizes.
As far as weight of the yak is concerned with manual handling, to get it to the water a simple trolley made from a super cheap fridge trolley will get the yak anywhere you want to go and you can build it yourself for not much more than the price of the original trolley $20ish. Check the DIY section for details. There are also simple solutions to loading on vehicles if you're at all concerned about this. Once again a simple search through either this forum or even youtube will see you armed with more information than you will know what to do with.
Most kayaks will handle most conditions you will encounter at Scarby, it may not be comfortable at times though. The real question is your ability to handle the conditions. Generally speaking, most people probably don't go out in anything greater than 15kts with anything coming from either North, South or East as it can give an ugly little chop to the bay which can combine with any latent swell or tidal currents and provide steep sloppy waves breaking from all sort of directions that are not a pleasure to be caught in. Westerlies will give you a little more of a window though, provided you don't stray too far from the cover of the land if they are really howling.
I hope I've helped. Might catch you out there one day.
MENS SANA IN CORPORE SANO