Galway native was a popular figure in League of Ireland and most recently was assistant manager at Galway United