In summer, these Scottish isles could be mistaken for a tropical idyll. But whatever the weather, says Lucy Gillmore, there's plenty to experience