William Norfolk, Governor of New South Wales