It’s not somewhere that’s often in tourists’ plans, but Chemnitz is hoping for some attention as a European Capital of Culture – James March explores this unorthodox yet charming destination