A Sneinton building which has had a £1m revamp to combine library services and neighbourhood police is now open to the public.