a plea for more cool weather sites for migratory travelers

Try state and local parks, generally you won't have water north of the Mason-Dixon but you can get electric. The Iowa state parks become first come first served after 10/31 and water won't generally be available, but you can get electric. Clear Lake State Park would appear to be on your way as an example.