The body of a British tourist that went missing during a night out in the Dutch city of Leiden has been found in a canal.