Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
When the arrow is in the status bar, then something is using Location Services. Otherwise, it shouldn't be in use.
 
Yes, it's only used when that arrow is up there, although there are some system processes that use GPS without the indicator popping up (by default). You can, however, enable it so that whenever those services use GPS, the symbol pops up.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.