Buckingham Palace aide resigns over 'unacceptable' comments made at Queen Consort's reception