This Jacobean beauty seemed to have it all, but its new owners felt like it was lacking its vital spark. Brought in to restore a sense of character, Nicola Harding embarked on a whirlwind revamp, transforming rooms with an artful palette and creating beguiling contrasts of dark and light