A new book recalls the musical institution on Cork’s Union Quay. Don O’Mahony finds out what made the venue special