A well-known Sheffield pub has closed - for a major refurbishment which will see it converted into a restaurant.