One of the smallest UK cities, which 'packs a big punch', will be instantly recognisable from popular TV shows