Diageo is to sponsor free public transport for London and Edinburgh's New Year's Eve revellers.