You can create a specific login for the application to use, preferrably from an Active Directory account. Next create a corresponding database user in each database the application needs access to. If you make that user member of the "db_ddladmin" database role it gets all the permissions needed to create/modify/delete database objects.
FYI, that does go quite a bit beyond just creating tables.