Kenneth Tindall's first evening-length ballet about the notorious lover is another success for Northern Ballet