A water tower is up for auction at £275,000 and could be turned into a six-storey home with countryside views across Cambridgeshire.