The House of Atreus -- which is to say, House Atreides -- figures heavily in Greek tragedy, as in the Oresteia of Aeschylus. The entire house was cursed by the gods for its ancestor's blasphemous (and cannibalistic) deeds.
Hence, Frank Herbert was making a clever classical reference in placing the House Atreides in the Dune series.