Cheshire pub opens after standing derelict for six years