The RTSP address comes from your camera. Depends on the brand, if it publishes to RTSP. I have one set of cameras that have the main RTSP view at something like rtsp://username:password@192.168.1.21:554/live/main. I have another camera that has the main RTSP feed at rtsp://username:password@192.168.1.22:554//h264Preview_01_main. It really depends on your specific camera.
It's possible that TinyCam has a different connection to the camera that is not RTSP. I managed to find an intent: link that would open the camera as ONVIF rather than just as RTSP:
With that, I can send Pan/Tilt/Zoom, which is different than just opening the RTSP link.
Once you have the correct RTSP link for your camera, if one exists, you should be able to open it either with TinyCam, VLC, or other movie players that can understand that format. If you've already assigned rtsp:// to another app, you might have to remove that default to have it open somewhere like TinyCam. I know TinyCam and VLC both play RTSP, though I'm sure there are other apps that will work.
Once you have the correct link, place it in a Link tile. I made my link tile completely transparent and place it above my image tile, which contains a PNG/MJPEG. The way to change the Link tile to make its background transparent is in Settings/Templates/Link.