Louis van Gaal has been appointed the new manager of Manchester United, the club have confirmed.