The chief executive of embattled booze giant Diageo will step down after two years marred by profit warnings, supply woes and a sharp fall in market value.