An “RV” type generator is the quietest type you can buy, but they’re expensive. They aren’t just “a regular generator with better insulation”; they’re engineered from the ground up to be quieter. All of that makes them more expensive. But if you’re going to be running it for more than a few hours in a residential setting, then it’s worth considering.
They produce CO gas as part of the combustion process, so they definitely have to be run (or at least properly vented) outside. (I expect that most building codes won’t allow them to be run indoors and vented, but it’s something you may want to consider for security. In a case where there’s a regional power failure or transmission line failure, which amounts to the same thing, “outdoor” generators will be precious – and may be stolen when it gets dark. And it will be getting much darker if there’s no local power.)
Some generators are “multi-fuel” capable, which would be handy to have if the power is out for an extended time and gas station pumps are idle. And that’s something to consider.
You will definitely need to have it wired into your home power board by a qualified electrician. The reason is that you don’t want to be back-feeding power to the grid, which can be dangerous for linemen working on lines outside your home which they expect to be “dead”. You don’t want to start killing linemen outside your house. Aside from the expense, I’m sure it would be messy and more than a bit upsetting.
As others have said, consider your bare necessities for power requirements: A small heater (to prevent the house plumbing from freezing, not to keep you “comfortable”), a few lights and power tools, perhaps, and that should be it. I’m sure that you can get by with a minimum sized generator.