First and foremost you have to find a finger and a slide that you are comfortable with. I went thru several before I settled on the Dunlop Preachin Pipe. I use it on my little finger. The slide you choose must fit right and give you the tone you are looking for. Experiment with glass, stainless, ceramic, brass, etc.
Playing slide in stardard tuning presents its own challenges. Most of the songs you associate a slide guitar with are probably in a non-standard tuning. I play in standard tuning too, it is possible. Look for three note chords you can play barred across one fret to spice up your leads.
practice
Dean