President Mary McAleese and Taoiseach Brian Cowen have paid tribute to playwright and self-styled curmudgeon Hugh Leonard.