Alcohol consumption in the UK has dropped for the second consecutive year, according to industry figures.