Blenheim Palace is set to unveil a new visitor trail exploring secrets and scandals from its past.