Whether you're seeking the echoes of ancient tales, the embrace of nature's grandeur, or the vibrant energy of urban life, Scotland's must-visit destinations have something for everyone