The difference in meaning and usage is slight between the two, and involves distance: "over there" implies the thing being looked at is farther away than when you just say "there." Some examples:
Two people are looking for a lost watch. One spots it, and says: "Look, there!" or "Look, there it is!" The watch in this instance would be, say, within 10 feet of the speaker. Close enough