The American designer of Germany’s long-delayed national Holocaust memorial has apologised for a joke that local Jewish leaders said made light of the Nazi gas chambers.