Alberca and piscina both mean a swimming pool, an artificial body of water.

Another word I heard the other day is charco. This is also a pool, but a naturally occurring one.