A campaigning councillor has hailed the return of a bus service to a village in his ward after years without one.