Planning permission has been granted for the proposed redevelopment of the vacant former Mansfield Brewery site to provide 51 residential units.