Yes, you can sign in and use the Library for reference-only purposes during core hours; you simply need to bring your home institution ID card and proof of your current address.
You could also apply to join the SCONUL Access Scheme, which may mean that you can use Northumbria Library as a borrower.