Iron Hands has a tutorial on making a watertower with a gothic look. It’d be perfect for Necromunda, Warhammer 40K or Warmachine.
water tower
Modeling A Western Style Water Tower
This tutorial explains how to make a water tower suitable for Wild West games.