All storage on that server is internal so no drive bays. It's far from ideal. And the server doesn't have any hardware raid. Also since some of the ports are SATA-2 they are not suitable for SSDs because they limit the performance to 50% of max. So you are really limited to two SATA SSD drives.
That being said, storing video streams are one of the applications where HDDs are actually very suitable. Depends on how much storage you want but if you need more than a couple of hundred gigs, HDDs should be your choice.
Assuming you want lots of storage I would get two 3.5" drives and run md software raid 1 on those. Something like 2-6TB drives. NAS drives (like WD RED, Seagate Ironwulf) if you are on a low budget, otherwise SATA enterprise drives (Seagate Constellation ES or similar).
I would also get one Supermicro SATA DOM (tiny enterprise SSD that plugs into SATA port) and put the hypervisor and VM's OS on that. Just have a backup in case the DOM ever fails.
https://www.storagereview.com/supermicro_superdom_review
I wouldn't get SSDs for storage for your use case - unless your needs are very small or your budget is big. But if you have a large budget I would get another server with drive bays.