Plans for a padel facility at a former Sheffield brewery, which is currently subject to major redevelopment plans, have been given the green light.