Refurbished Rochdale pub to revitalise community