The Castle has hosted some memorable nights with great sporting legends like AP McCoy and musicians like Damien Dempsey.