A “disaster movie” Wiltshire road destroyed in a major landslip is set to reopen three years later.