A derelict former builders’ yard has been transformed into an upmarket events venue in a trendy Sheffield neighbourhood.