What you want to address here is cell size.
This type of foam is categorized by the size ot the individual air-bubble
cells that it is comprised of. Large cell size = low density, extremely
porous. Small cell size = high density, tiny cells, less porous.
Great stuff foam is largely inconsistent in cell size, but at it's very best it
is probably a little too porous to use as a finished product. High density
foam is available through specialty insulations companies.... and can be
VERY expensive. But if you find a company near you, you might be able
to ask if you could have their scrap.... which they usually throw away.
Look up Specialty Insulation Products in your yellow pages.
Also note that even high density foam will need a coat of something like
fiberglass resin to seal it and give it some strength.