The Liverpool defender became a club hero after the Reds won the European Cup in stunning fashion back in 2005