One happy but largely unsung result of Ireland’s prosperity has been the creation of quite spectacular new art centres in provincial towns, Louise Cotter has visited three of them in Thurles, Navan and Drogheda