Plans to relocate Durham County Council into a new HQ have been approved as part of a major redevelopment programme.