A Northumberland castle which has been shut to the public must reopen “as a matter of urgency”, Hexham's MP said.