The former Real Madrid, Spain and Wolves coach will replace the outgoing David Moyes for the 2024-25 season