We had a transfer switch installed a while back for the same reasons... water, heat, toilets, sump.

Cost was hundeds (not thousands) and absolutely the best money we have spent in years. Now any generator including our portable can run the essentials without pulling out appliances and dangling cords through windows.

HIGHLY recommended.