Which server roles should be assigned to a new user for database creation?

Assign all permissions under Server Roles (or at minimum ensure 'public' is supplemented with necessary privileges), as these are required for database creation—other roles can be removed after installation.