“Cite” is a verb meaning “to mention” or “to make reference to”:

She cited the Journal of Atmospheric Sciences in her paper.

“Site” is a noun meaning “location”:

Raleigh is the site of the new mine.

“Sight” is both a noun and a verb that refers to seeing:

We sighted the white smoke plumes before we reached the lime mine. It was quite a sight.