The fortunes of a neglected Georgian shooting lodge in Herefordshire with a fine pedigree have taken a decided turn for the better in the past few decades, and it is now back at the top of its game after a glamorous reinvention by designer Francis Sultana