Sheffield’s ‘best place to live’ has been lovingly sent up by a famous comedian in a new BBC show.