“I think I dream in paisleys, so, for me, this collaboration is just a dream come true,” the singer songwriter tells Vogue