How do I add spell effects to a map?

I need to have an effect from a spell playing in a specific location on the map, preferably continuously, and even better if it triggers when you approach it, etc., but that's a different story. For now, I just need to set up a spell effect at a location on the map so that it plays continuously. How do I do that?