Cathal's brother would be Mickey MacConnell. This song is from his album Peter Pan and Me (1992). The song you're after is called The Clown.

I can't give you any more info than that at the moment. Most of the album isn't available online, and copies are selling for a pretty penny. His website describes the song as follows: "The death of a clown is perhaps in many ways a musical cliche. Anyway, this is my take on the theme written from a Fermanagh point of view."

There's also a contact link on this page; maybe if you reached out he could help?