Standardize city name data to a consistent canonical form. Handles abbreviations, alternate spellings, and local variations.