A man who went missing while visiting Edinburgh relatives for the festive period has been found safe and well