When spending a fall weekend in one of these cities, these pumpkin delicacies are worth the detour