A Procurator Fiscal is responsible for prosecuting cases in the lower courts and conducting initial investigations, whereas an Advocate Depute handles more serious and complex cases in the High Court of Justiciary.