The Microsoft SharePoint look book site is a great source of ideas and the templates to implement them. The templates are mostly for sites which are part of a corporate intranet but they also include an employee onboarding solution which is externally facing.
As well as providing inspiration there is also a Microsoft 365 learning pathways site which contains excellent training resources covering all the components of Microsoft 365.
You can stay up to date on the latest features in SharePoint, as related to its use as an intranet, on The Intrazone podcast.