New research reveals stark differences in how communities in UK say they are faring