Major drinks producers in Scotland are set to work with authorities to stem the tide of alcohol misuse in the country.