As he signs up to a new campaign, the former England football legend encourages people to drink responsibly