Hull Community Pub Society says agreement has been reached on pub’s future