The existential construction takes there as a subject. There has no meaning, and often the verb takes its agreement from the complement of the verb BE. So if the Noun Phrase after BE is plural, the verb will be in a plural form. If the Noun Phrase is singular it will susually be singular:
- There is an antelope over there.
- There are some antelopes over there.
Notice, however, that in the examples above, the subject and the verb BE are not contracted. In normal speech these will nearly always be contracted. We will use there's instead of there is. It is also quite common nowadays to see them contracted in writing, and you can find instances in prestigious newspapers like the Times, for example.
Now when the subject there and BE are contracted like this, the verb doesn't need to agree in any way with the following Noun Phrase. Therefore with regard to the Original Poster's example:
There is people with standards and people who have fun.
... this sentence would be regarded as ungrammatical by most, if not all speakers. However if they had contracted there and BE, then it would have been grammatical:
There's people with standards and people who have fun.
This would have brought this into line with Lennon's:
Imagine there's no countries.
Or sayings such as:
There's many a slip twixt cup and the lip.
Or usages such as:
There's times when I've wanted to box his ears
Having said this, despite the fact that this is a well documented aspect of the grammar, some nimby prescriptivists are bound to take offense at this. They will insist that it's ungrammatical to use a plural noun after there's. This will be despite the fact that they quite subconsciously actually use plural nouns after there's themselves quite frequently. They will appear about five minutes after I post this answer. They do make life fun though!