From East Rutherford to Foxborough, the world’s biggest sporting event landed in some of America's smallest municipalities — and left mayors to pick up the tab.