I don’t know much of scripting, and I want to create some effects that require the textures on mesh objects to pan back and forth or fade from one texture to another. Is it possible to do without creating a script or maybe a place to get some scripts already written that do this?
Unify Community has some scripts that may help you here :
for Fading : http://wiki.unity3d.com/index.php/Fade
for Scrolling UVs : http://wiki.unity3d.com/index.php/Scrolling_UVs (this is in C#, I can supply a JS version if you like).
However, you may want to look at what is available in the asset store.
There are alot of useful scripts on Unify Community : http://wiki.unity3d.com/index.php/Scripts/General
You can use the Animation Editor (Ctrl-6) to pan the offset values. Fading from one to another probably best facilitated with a shader that takes two textures and a blending value, which would then be animated.