President-elect Joe Biden has nominated a longstanding critic of Brexit to a key post overseeing European relations in the US National Security Council.