A memorial service has been held for former Sky News presenter Dermot Murnaghan, who died in July after a distinguished career at the top of UK journalism.