The first one doesn't make sense, no.
It would be 'Happiness is something that all people are looking for.' If you would like to include the it, you could instead use a semi-colon to link the 'it' into a new sentence. For example:
'Happiness is something that all people are looking for; it is a psychological need' or something to that effect.
Hope this helps!