If we can get a recycled water system which is either continuously pushed through via pressurized changes or perhaps an appropriately placed Aero spell? And! Magical we can add an enchantment on the bottom to push in ice spells, it could work really well as long as the tubing is durable enough to withstand! Also if you make it glow, it could be a good beacon to incoming ships!