The head of Diageo has warned that the offer of public funding alone will not be enough to reverse the company's decision to cut a net 500 jobs in Scotland.