I'm using no-ip.com in "Port 80 redirect" mode - in fact my provider doesn't mind port 80 being used it's just I don't want to reveal my static IP. When I type the alias (from either local or remote locations) it gets picked up but then the page gets refreshed and my static IP gets displayed instead of the alias. Is it a by design behavior or how can I fix it otherwise?
It sounds like your LAMP is redirecting to the IP address. Ensure that you have your Virtual Hosts setup correctly using the domain assigned by No-IP.com.
Furthermore its important to note while using a no-ip.com will not hide your IP and can be found with a DNS resolve. More on this below.
Free VPN - Slow (Overused)
VPN Premium (Fast - Not Free)
VPN Finder (Reviews and Deals of many VPNs)