My first thought was to echo Jonny_LA and Lancia’s concerns, my grandparents lived 1-2 miles out of town with their own well, septic, etc but with grid power until they got too old (80ish) to handle the maintenance then moved back into town. Sounds like you have considered that part. So, going on to the practical considerations:
My mother, step sisters, and many cousins do live with grid power but with a well, septic and the propane truck coming by once/twice a year (or haul a couple of 33lb tanks into town to fill up as I did just for niece last week). I don’t consider that off grid, just standard rural living. My only truly “off-grid” experience is in vacation cabins or living in a trailer for a hunting or road trip. Longest was for about a month, in December, in Utah. I have also spent a lot of time dreaming of moving to my own place way out of town so have thought about the problems.
Hauling enough water to drink/cook is no problem. Hauling enough to flush toilets, bathe, or do laundry is very hard. If you can get a well (which sounds likely based on your description) that is the way to go. A good well is safe to drink without any extra treatment. Here in the desert I have considered catching rainwater from the roof and using a cistern, but that is more trouble than a well.
If you don’t have grid power, you just don’t have energy like those of us in the modern world are used to. You can live that way, you just need to adjust. I recently took my current energy usage (all electric house) and estimated enough solar to keep the same usage with enough battery for 3 winter days and it priced out around $76k. It scales roughly linearly with usage, so the key is to get energy usage down.
I would go with solar/wind with a battery bank. Maybe a backup gas/propane generator. How big to make it will depend on what ends up needing to be electric. I would make it as little as possible. Use 12V DC trailer/RV appliances and lights. This cuts out the inefficiencies of the inverter and can run straight off battery power. You can watch TV, charge a cell phone, use a laptop, read a book or run a propane heater. The same heater that can keep a 50-foot poorly insulated/leaky trailer comfortable should have no trouble keeping a small, well insulated house warm.
Things in my trailer living that needed the 120V power were the air conditioner and microwave oven. Used a propane refrigerator. We always went into town to do laundry, but I would expect a washer to also need 120V. Skip the dryer if the climate at all allows it (a clothesline in the living room near the wood stove drys things fast).
Air conditioning is a luxury, winter heat is a necessity. People lived all over the world before air conditioners but only moved out of the tropics after mastering use of fire. Insulation and passive solar will be needed for winter, and good ventilation for summer. Pellet stoves do work, they are more convenient than wood stoves, but have the same ash problems as wood stove and stops when the power goes out. A trailer/RV propane heater would be easiest, but also stops when the power goes out. I would consider a wood stove a requirement, even if it is only used as a backup. I’m a bit younger than you and still vigorous enough to cut/split/stack it myself but can see they day rapidly approaching when that will no longer be true. Just pay somebody to do those parts for you. If it is only backup a wood pile will last a long time.
Now, going from experience to just what I’ve read/planned/dreamed about. The key to keeping energy use down is insulation. I like the idea of straw bale construction, but it is more DIY than contractor. Also may not be appropriate in a damp climate. Other methods I’ve looked into are Structural Insulated Panels or Insulated Concrete Forms. Check if any builders in your area are familiar with these.
Have a single “wet wall” where all of the plumbing for both kitchen and bathroom are together. Kitchen on one side, bathroom on the other. Make sure it is an interior wall so it doesn’t freeze.
Spend the extra on windows with multiple panes and IR coatings. Cut my heating bill in half going from 1940’s windows to modern. Design in passive solar heating from the start. Have eaves long enough to shade the south facing windows in summer, but short enough to shine in the winter. I’ve long wanted to try this kind of passive solar heat panel: The Zen of Passive Solar Heating Panel Design (I’m a DIY kind of guy).
Electric wise, run two sets of power lines. Both the 12V DC and a 120V AC line. If the fridge is propane, have an off switch on the inverter so it is only on when you need it. The standard for 12V plugs is the “cigarette lighter” round type. Have one of these at the outlets along with the standard 120V plugs.
Make sure the well pump is 12V so it works when the 120V is off. A standard thing to have is a pressure vessel so the pump doesn’t need to run to get water pressure. It is a big tank with an airspace at the top, keeps pressure on the system so just opening a faucet doesn’t make the pump run.