You need a responsible neighbour looking after your place when you are away - one who knows about sump pumps or at least can call in a maintenance company. Check your house insurance requirements for any need of house-checking if you are a longer trip.
Apart from the internet/webcam, you will also probably need what is called a static-IP address. Virtually all home networking is done with dynamic IP addresses which means they can change. So if you start out with a working system you can monitor the IP address could change stopping you from connecting to your camera.