Castiel makes his debut in Season 2, Episode 22: "All Hell Breaks Loose."
He is introduced as an angel sent by Heaven to help Dean and Sam Winchester fight the demon Lilith.