What will happen if I deactivate an artifact type at the project level?

The artifact type will not be available for entering new artifacts. However, it will be available to query for existing artifacts of that type and you can view them in read-only mode.