Horus Menhoset IX appears in game when you are on Ava Cadavra's task to find a pyramid in the desert. He will eventually help you smash the Bovine Shrine and replace it with the statue of an Egyptian god. You will need to stock up on gourds and sacrifice them to the statue in order to keep Horus from a trance state where he won't move or talk to you.