Tributes have been paid to a much-loved family man and father who died in a collision