Connecticut has them at the state level. New York City has a sheriff, but the city is its own identically named county, so I'm not sure how that works exactly. Wasn't Andy Griffith in the same situation, where his town and county were both named Mayberry?