River Tweed fishing museum set to open