"I have no spoon." Correct in a situation where exactly one spoon is expected.
"There are no spoons here." Correct in a situation where there could be zero, one or more spoons.
There is no spoon in this room. Equivalent to "There are no spoons in this room".
There is no spoon in this room. Equivalent to "There are no spoons in this room".