Stringer will lead a group that hands out £100,000 each year to various schemes across Scotland that promote responsible drinking.
The fund was set up by the Scotch Whisky Association in 2013 and is managed by independent charity Foundation Scotland.
Stringer said: “There are many innovative projects which will benefit from the fund and I am committed to having an active role in its development and spreading the word across Scotland.”
She is currently principal and vice chancellor at Edinburgh Napier University – the first woman ever appointed as head of a Scottish university – and has worked in higher education for more than 30 years.
David Frost, chief executive of the Scotch Whisky Association, said: “Alcohol brings a range of benefits to Scottish society and economy, but we realise there is a problem with misuse that must be tackled. The fund, with Dame Joan as a driving force behind it, will help in the fight against misuse.”
The first projects chosen by the awards panel to be supported by the fund will be announced shortly.