I have the Costco Body Glove inflatable and take it when we camp at the lake a few times a year. It's a good work out. I was actually a bit sore in my quads and lats after doing it more this trip than before as the water was so nice and each day was 90+ degrees. Great for working on your balance.
My dog will go for short trips somewhat reluctantly. If I got more into it I'd get a solid board. The inflatable will flex in chop and the heavier you are the worse that will be, but they are pretty cheap and a good way to get started.