Police in Nova Scotia have found the body of a man who went missing amid historic flooding over the weekend, confirming the first victim of the tragic event.