Former Stones Brewery site to be transformed into homes after 20 years vacant