First off, congrats on retirement,
Established campgrounds, or dry camping?
FHU or is just water and elec ok?
Resort parks, or COE/state parks?
If you haven't travelled this way, you will need to find what fits you, and go from there,
Don't put a schedule in place that over taxes you, plan around maybe a single travel day, 2 at most, and then sit for a couple of days, explore the area, sample local food, take part in the types of activities you like. (hiking, museums etc) Give yourself enough time to relax before planning the next stop.
Maybe a couple of nights somewhere with FHU and a lot of activities, tours, or whatever, then on to a state park for a few quiet days. You can pre plan that first trip giving yourself 2-3 nights at most stops, and then decide if you want that in the future, or to just decide on a day by day basis where to stop.
We do tend to alternate from FHU to just W/E sites just to avoid the extra stop on departure for dumping tanks, but we are comfortable in our usage for 5 days.
Within a couple weeks, you'll get a rythymn and find what fits.
As to carrying water, we do, we always have a half tank or more, because we don't always know where we are stopping next.
Also plan to visit busier areas, national parks, etc, in the months kids are still in school fewer crowds for you and you can look to the non jellystone parks for summer months.