[Metadata composite keys] Update `set_primary_key` docstring to indicate a list of columns is now valid

[frances-h]

Environment Details

Please indicate the following details about the environment in which you found the bug:

• SDV version:
• Python version:
• Operating System:

Error Description

The docstring for Metadata.set_primary_key should be updated to include the argument descriptions and the allowed types (i.e. column_name (str or list[str])). We should also update the docstring for SingleTableMetadata.set_primary_key.