Northumberland County Council's cabinet have agreed multi-million pound plans that will see a prominent commercial building in Blyth converted into apartments.