German Chancellor Angela Merkel is the "right person" to protect the European project throughout Brexit negotiations, a key political ally told CNBC.