How to achieve 1km Non-Line-of-Sight Wireless Communication without Internet

But LoRa will not be able to transmit the video data.

One step at a time is good, but those steps need to follow a plan. The plan will often need to change when you learn from mistakes or encounter unforseen problems, but, even so, you should make a simple plan before you begin.

To carry the video data, you will need something like wi-fi which has a high bandwidth. A WiFi signal can cary your pan/tilt data also, so that only one data system will be required.