If you're willing to make the trip to the suburbs, check out wonderland. Weather will be bearable during the fall, and the place has enough attractions to keep the kids occupied for the full day.

Could get expensive though, so research this beforehand. Also don't buy tickets at the gate, as they're very expensive.