Water’s easy. The drain may be more difficult though, especially if you have to get a building permit and have it inspected. With the sink, you will be adding another ‘fixture’ to the drain and vent system already in your house. Depending on the size of pipe, length of run and number of fixture units already on this leg, you may not be able to add another (per code). It’ll work just fine, but building officials can be real anal about interpreting code.
For ideas, you might want to go to a few furniture outlets and see what they have for “ready to set in place bars”. Take a few pictures and then design your own. Just ‘borrow’ some elements of their design. Also, go to a couple cabinet retailers and look through some of their magazines. You also might want to look at some appliances. They make some very trick built in appliances that are small enough for a bar (ice maker, dish washer, wine cooler, fridge, keg-er-ators, etc…).
