A man who was tragically killed in a collision alongside his beloved dog has been named and pictured for the first time.