Just under 3,000 new homes need to be built in the whole of Powys by the end of 2037, councillors have been told.