It's a singlish word or Malaysian slang word. 'Niao' is usually used as a description of people who are very fussy about something or just overreact or overconcerned about a situation.
People can say ' Ben is super niao, he don't even want to share the same cup as his sister.'