Deal to buy Kevin Street site expected to be finalised in weeks with former offices expected to be replaced with housing