A man who died following a two-vehicle crash in Dumfries and Galloway has been named by police.