500lbs is about the weight of three average people. I don't think storing that amount of water would be a huge problem.

There are some interesting sized containers out there. Water bed anyone? a few 55 gallon drum's with a board over the top and some framing and a few stools could make a descent bar if you have the space. Move off campus and have a nice party.