A "lifelong musician" and mother-of-four said it was "humbling and joyful" to be appointed as the next bishop of Doncaster.