It seems there's no "incite city revolt" option for my spy in early age.
Then when can I do it?

and if I keep "causing unhappiness" in the target city, will it revolt?

You need to build up enough EP. And, no.

:goodjob:understood...