In terms of transport Sheffield is sat on the Midland Main Line, a line connecting the area to the midlands and London, and the Cross Country Route linking the city to the north and Scotland. To get around the city there are various bus routes and the Supertram system.
For visitors there are a wealth of attractions in the area. These include The Sheffield Walk of Fame (similar to the one in Hollywood, although this is more glamourous!), for animal lovers there is Heeley City Farm and Graves Park, for history and architecture fans there are over 1000 listed buildings in the city! If that's not enough to keep you busy the city centre offers excellent shopping, dining and nightlife.