Council set to borrow millions of pounds to transform skyscraper