When trying to find the path to the Library folder while trying to backup my Kodi user data, I realised that the Library folder is hidden when navigating to the path manually.
Previously I was able to display it by simply going to Finder>GO> Then holding the option key which reveals the Library option on the drop down.
If you wish to show the folder permanently, there is a way.
While in Finder hold press Shift+Command+H and you will automatically be dropped into the user home directory. From here you can right click and click on Show View Options, tick the Show Library Folder and close the pane. If you wish to hide it and then simply uptick that box.