Who is Microsoft Stream intended for?

[#1]

Might be worth starting here: What is Microsoft Stream?

[#2]

It depends on your needs. It is available as stand alone service but also as a integration with your Office 365 tenant. And it is the replacement of office 365 videos