Man United transfer target set to sign for Premier League rivals as saga finally comes to an end