For two decades, the influential British thinker obsessively recorded views of Venice and St Petersburg