I've also taken the kids kayaking there. It's very safe and the scenery is lovely.
Probably ideal for what the OP wants if they can get there early and get a parking spot right up the end by the slip way. That car park does get exceptionally busy this time of year.