Yes you are correct that if your password expires then the data source will fail to work.

Personally I would go for the second option, and set it as a user whos password will never expire. That way you still maintain all traceability of who has done what.