Tributes have been paid following the death of renowned historian Sean Pettit, a specialist in the history of Cork.