Few mayors run for higher office. And female mayors are even less likely to view positions such as governor and U.S. senator as appealing.