Can a source number set for an outbound text message be a non-Plivo number?

No, you can only set your Plivo numbers as a source number. This is due to telecom regulations.

You can, however, make an outbound voice call using Plivo APIs with non-Plivo caller ID.