Restricting Database Access/Functions to User Groups?
Server roles are made for this. 

Read this for the details http://msdn.microsoft.com/en-us/library/ms188659.aspx 

The dbcreator role looks like what you are looking for.