Six-month stint in influential European council deal-making role will consume a lot of Government’s bandwidth