They are water fiends, and will break into your water main line, or anywhere else that has water.
As long as you give it good space, monitor its roots, provide adequate water and pick the right variety of Willow for your area, it'd probably be fine.
They also have shallow roots, so can blow over easy in some circumstances.