Source, activate on create MV

[purplefox]

Sources start ingesting as soon as they are created. In some case, e.g. creating an MV on a transient source, we don't want to start ingesting until the MV is created, so as not to lose some messages.

We should support an option when creating the source so the source will not start until the first MV has been created.