A self-contained ready to deploy CCTV solution based upon newer high quality IoT camera compute systems with open-source software could address most of the problems.

It could cost bit higher than buying the cameras and setting up our self a CCTV solution on an old computer but the cost can be recovered soon as most cloud solutions associated with proprietary camera systems incur significant cost perpetually.