My son and I have rented and done this on the SF Bay a few times:
I've wanted to buy, but I've been a puss about transporting a hardshell, so I've been posing with an inflatable that I bought last year, albeit a higher end one (Advanced Elements). It's actually a hybrid folding-frame, inflatable. Anyway, it's a lotta fun being out on the water.