How can I create nice looking texture for an rts I am making. I want to make mainly water, rock, and grass. Are there any tutorials on the subject?

I still find these articles pretty good, though keep in mind that it's simply going to take a lot of work and experience to get such high quality art done. Tutorials can only help so much, they won't do the work for you.