Your entire concept is bankrupt because you can't reliably heat the cabin. No matter what you do, when the cabin power/heat fails, the pipes will freeze.
The problem is, the water pipe can freeze anywhere from where it first rises above the frost line underground, to anywhere in the cabin.
Your frequent power failures are a deal-killer here. A diesel/propane autostart generator for a totlly unattended cabin is just crazy! So you will either need to come up with a Tesla PowerWall type scheme, possibly augmented with solar panels; but that will not work if your heat is electric or heat pump*. Or else some sort of electricity-free furnace system running off the propane tank, like the Empire style floor and wall furnaces widely used throughtout California and Florida. So I would go with one of those, if you didn't mind being the only one in Ontario. For some reason, despite the desperate need due to frequent power failures, no HVAC dealer in the snowbelt has ever heard of an Empire furnace.
- Note that if you are currently all electric*, and add an Empire, you will need propane service
To keep the pipe above the frost line from freezing, I would sister it with 2 or 4 larger pipes, wrap those with 6" of foam insulation, and circulate antifreeze through the 2 other pipes up to a heat exchanger inside the heated cabin. This will not require much circulation; a tiny pump of a watt or two will do; and this could be on a battery with makeup power coming from hydro, a small vertical solar panel, or both at once.
* readers, electric heat is common in Ontario due to a glut of hydro and nuke, in fact "hydro" is slang for the power company. Their other plants are shamefully coal-dirty, but the hydro/nuke has such a large chunk of the pie that they are probably the most renewable province/state on the whole continent. Assuming you count thorium as "renewable", and their wackadoodle CANDU reactors lend themselves to thorium.