I think if the tanks were cleaned well the spray foam would stick. Maybe afterwords you could wrap the tank with a heavy duty exterior fabric to help hold it in place. The wind may get the tank to the temperature outside quicker but will have nothing to do with freezing, If it is above 32 nothing is going to freeze no matter what. I believe if you insulate the exposed side completely and you have the top of the tanks exposed to the heat of the cabin you would help pretty substantially. You can buy a larger size tank of that spray foam from some big box stores that is used for insulating rim joists in construction. The stuff has a great R value and is some sticky poop. Also you could dump a little rock salt in the tanks as this will lower the freezing temp. We did that for years when we went ski camping. But if your talking real cold like 25 and below you better look into some tank heaters as another poster said. All though rock salt will work pretty darn good. JMHO