Roddy Collins, one of Ireland’s most colourful characters, is back in management after he signed a two-and-a-half year deal to take over as Waterford United boss.