You need to own a game that uses the Source Engine, like HL2 or counterstrike.  I beleive there is a list on the wiki.  
The aim of the GES team at the moment is only to create multiplayer. SP might be done in the future, but it is a long way off and there are no plans right now.