Paul is looking for an HD security camera, where he could save and then edit the videos. Leo says the Google Nest cameras are good for that. They are very high resolution, but they use a lot of bandwidth upstream - 1 Mbps per camera. That could kill his internet in some cases. He may also have to pay for offline recording. He'll be able to download the video and edit it, though. That's probably the easiest way. Otherwise he'd have to wire the cameras to his computer and capture it directly.
For local recording to an SD card, Leo recommends Axis. They have both hosting in the cloud or local storage.