Premier League cult hero with iconic goal celebration announces retirement aged 39