The Vivienne, whose real name was James Lee Williams, was confirmed to have died at the weekend