Discourse can function as an SSO provider. It would be possible to set this up with Drupal, but I’m not aware of any existing Drupal modules for it. For details about what would be required see Use Discourse as an identity provider (SSO, DiscourseConnect).
If you’re not committed to using Drupal, the Discourse WordPress plugin allows you to use Discourse as the SSO provider for a WordPress site.