> (1) Upper floors of a skyscraper is probably the most expensive place you could store water in.
Water pipes are pressurized using gravity (there's a reason tanks for water distribution systems are commonly referred to as "water towers"); indeed, water systems frequently measure pressure using the height above sea level it can reach without pumps rather than more natural units of pressure. If the city's water mains aren't capable of pushing it to every floor of your building (which is going to be true for a skyscraper), then you'll have to naturally pressurize it yourself by keeping the main water tank high.
If you don't do that, your options are either to pump the main water main anyways (just without a natural tank on the top), with lots of pressure regulators for the lower flows; several vertical water mains to service different vertical pressure zones; or one water main with lots and lots of smaller (and hence less efficient overall) pumps to keep the pressure reasonable at different altitudes. Keeping the water tank high instead lowers the amount of infrastructure you need, lowers the costs of regulating pressure, and has better fail-safe conditions if the power cuts out for a while.