Relatively few Brits visit this tiny Pyrenean principality outside of the wintersports season. But Julia Hammond travels there by the scenic route to find there’s plenty more to recommend it than ski slopes