My wife has this inflatable and she likes it. She and her SUP buddies do sunset cruises with wine and fancy treats so it will definitely haul a small cooler and has tie downs to secure one. Very easy to transport and store. https://www.amazon.com/...=tower+paddle+boards
I am surprised how rigid it gets when inflated - it is like a Zodak boat, not an inflatable pool mat.
I don't paddle but if you get a good inflatable, my understanding is they are as just as good as a rigid board until you start looking at high performance or racing boards. Perfectly fine for what you are contemplating (assuming your kids are not squirmy - a canoe or kayak is probably better for hauling little kids.