Robin McKelvie marvels at the irrepressible energy and vibrant attitude of Kirkwall