In the statement, acting chief executive Craig Tiriana said Pewhairangi was selected from "strong" candidates.
"This is a big role within our organisation, responsible for more than 100 staff as well as key outcomes for our community and we look forward to welcoming Mr Pewhairangi as part of the executive team."
Tiriana said Pewhairangi, who is currently director Māori in the police's Māori, Pacific and ethnic services, came from senior leadership and broad operational experience, and had well-established iwi, community and council relationships in Rotorua.
"He has an inclusive, values-based style and is passionate about building thriving and safe communities, which is a key priority area for [the] council.
"We look forward to his strategic input into addressing the challenges Rotorua faces and delivering positive outcomes for our community."
In the statement, Pewhairangi said he was "excited" to join the council, having previously enjoyed a good working relationship with it as Rotorua area commander.
"I have been impressed by [the] council's vision and direction and the collaborative approach to building not just thriving, but resilient communities, and the focus on ensuring effective partnerships with Te Arawa, our local iwi.
"I want to be part of the change, the important mahi that the council is doing to future-proof and transform Rotorua, and am excited to serve our people and our communities."
He said Rotorua had been his home for almost 10 years and he looked forward to reconnecting with the community and contributing to the "important kaupapa for the greater good of the rohe".
The role was responsible for the various functions in the council including community safety, open spaces, sport and recreation, facilities, "community regeneration" and facilities including the Sir Howard Morrison Performing Arts Centre, the aquatic centre and museum - all of which have work under way either for earthquake strengthening and or renovation.
Pewhairangi, as community wellbeing deputy chief executive, would also be responsible for the library and the establishment of community hubs – a target in the council's 2021 Long-term Plan.
A school teacher for eight years, Pewhairangi worked for the police for 20 years, holding leadership roles.
Pewhairangi is of Ngāti Porou, Ngāti Rangiteaorere and Ngāti Tūwharetoa descent. His wife Shelley, is a former police officer who tutors at Toi Ohomai, teaching in the police and defence forces course.