Once home to poets, musicians and more, the newly-announced UK City of Culture 2017 has more claims to fame than you might think