Leigh twice came from eight points down to beat Sheffield Eagles 43-28 and lift the Northern Rail Cup for the fourth time in 10 years.