Career diplomat Tim Barrow will replace Ivan Rogers as the UK's top civil servant in Brussels, sources have confirmed.