The drinks and hospitality industry provides more than 200,000 jobs according to a study released to coincide with a campaign to promote local pubs and restaurants.