Over half of tourists visit Ireland because of the pubs, making it the second most popular reason people come here, according to a new survey.