Regarding Google Fonts, you can use tools such as google webfonts helper to download the fonts. These usually also offer the entry for the CSS file.
In my case, I have saved the font files in the subdirectory static/fonts/ in the theme directory (https://github.com/Fryboyter/Hugo/tree/main/themes/GythaOgg/static/fonts/titillium).