The two i'm aware of for Northern California. Not sure how active they are but see below.
https://centralcoastkayakfishing.com/
http://www.norcalkayakanglers.com/in...p?action=forum
P.S As far as Kona goes, I spent a lot of time looking for a kayak guide out there but didn't find much. The guys I found were not very responsive. Ended up renting a boat and doing some trolling for nada. Also keep in mind that most of the reef species are not edible in Hawaii.