From allegory to advertising, artists have frequently depicted the pleasures and pitfalls of drink in their work.