A key road through Wiltshire has been reopened three years after it was destroyed.