From Snøhetta’s $245 million Central Library in Calgary, Canada, to Berlin’s ‘eco-intelligent’ Philological Library by Norman Foster, these stunning spaces are anything but quiet