When Manchester United appointed Louis van Gaal as manager in May 2014, the veteran Dutchman was widely expected to restore the fortunes of one of the world's biggest football clubs.