The director of the Sistine Chapel Choir, which has provided the musical backdrop to papal events for centuries, has resigned following allegations of fraud and embezzlement.