Family devastated after missing dad confirmed dead