Do I need to explain my reasoning when choosing between two offers
No.  You do not need to explain your decision.

Assuming it's actually true, it would be appropriate to tell the department you're turning down that their offer was attractive, and that it was a difficult decision, and that the choice came down to non-academic factors that were out of their control.  But even this is more than you need to tell them.