Visio handles scaled drawings as well, so you might be interested in a
combination of both custom page size and page scale.
Anyway, go to File > Page Setup. On the Page Size tab, you can enter any
size you'd like. On the Drawing Scale tab, you can set scales (like
1:100, 1:50, etc)