Gods dying and the legends rule
Yes, the ability of the God that remains on the battlefield will trigger. When you play the second copy of Athreos, you will control 2 of them. Then, when state based effects are checked, by rule 704.5k, you have to choose one to keep and move the other to the graveyard. This triggers the ability of the one still on the battlefield.