Sweeney tapped as village manager