In “The Pie At Night: In Search of the North at Play,” Stuart Maconie weaves humor and introspection as he roams Scotland’s rugged coastlines, uncovering hidden stories, culinary delights, and the quiet resilience of its people.