Re: do the positive words need to be "seen"?
I don't think water as too "see" the words to be affected by its vibrational frequency. However any metal may or may not hinder it's efficacy. I'm basing this fact on biofeedback analysis where metal is known to disturb readings of emanated frequency.
You may want to avoid opaque materials for other reasons though, specially if made of plastic. You don't want the chemical to leach into your water.
Glass would be ideal as it is relatively inert; certainly exposing the water to sunrays can also be beneficial, another reason for glass containers. Colored glass containers can very good as they add "color therapy" effects into the water. It is known that colors affect moods and conversely the immune system the same way your water is affected by your emotions (it's all vibrational frequency after all).
Stable ceramic cups are also acceptable in my view.
You may want to focus your intention when writing and labeling the bottle as to imprint strong vibrational frequencies with the words. The same word can affect me and you differently so it's important to put your personal intention into it.
Mike